Definitions

DataBlock

The DataBlock is the foundation from which all reports are created and contains Forms and Queries.  Only users with DataBlock Designer privileges can create DataBlocks.

The Queries obtain data from a database.  When results of queries are displayed on a form as shown in the figure below, this is called a Dashboard.  In the case of CSV, Banded, and Extract Reports, the results of the queries become input to the report design with the results displayed or stored elsewhere.  Within the Argos Explorer tree, reports exist as "child" objects of a DataBlock. 

Reports as children of a DataBlock:
Reports listed under a parent datablock in the explorer tree.
All report types residing under the same DataBlock use the same form. Reports are “children” of the DataBlock.

The Form created by the DataBlock Designer using the Argos DataBlock Designer, is used for two purposes:

Whenever a user executes a report, the form designed as part of a DataBlock will be displayed as shown below. The input selections made by the user become query parameters.

DataBlock form containing objects for accepting query parameters and an object to display query results.

A Form can contain various types of objects such as:

Form Queries and Report Queries:

The Argos DataBlock Designer is used to create the forms and contains tools for adding objects to the form. The figure below shows the form design for the report shown in the previous figure.

The DataBlock Designer when creating or editing a form.

The objects created on this form are as follows:

Other object types could have been included on the form.  For example, a chart or OLAP cube could have been designed with its results displayed on the form.  A description of available objects is included within the next section.

It is important to note that certain objects (such as edit boxes, list boxes, etc.) can be used to obtain input from the person executing the report and can also be used to display the results of the query.  In this example, multi-column list boxes were used to select employee names and also to display the results of the query. Other types of objects can also be used which are able to obtain input and display results.

The advantage of having reports tied to DataBlocks is that you don't need to create separate input selections and separate queries for every report you create. Similar reports can share the same form, and the same query.

As mentioned earlier, CSV, Banded, and Reports use the same form as Dashboards within the DataBlock to gather input selections. However these reports do not display data on the form as is done with Dashboards.  Although CSV, Banded, and Extract reports share the same form within a DataBlock, they do not share the same query with a Dashboard (this will be explained further in the examples section of this document).

The components of a DataBlock described above mention that the DataBlock contains a form and query; however DataBlocks could contain multiple forms and queries.  Creation of forms and queries (Form Queries) used for Dashboards is done within the “Form Design Tab” within the DataBlock Designer.  Creation of a query used by CSV, Banded, and Extract reports (Report Queries) is done within the “Report Query – Visual Design” tab. The creation and use of both types of queries will be explained in the examples that follow.

OLAP Data Cube

OLAP is a specific way to represent statistical data for executives, specialists and analysts. It is designed to aid in decision-making and better information understanding.  The main idea is to answer the user’s questions, arising at the work time, on-the-fly, quickly.  A popular definition is “A million spreadsheets in a box.”  The key to OLAP is its ability to allow the end user to configure different views of the same data. 

An OLAP system allows user to get into details or generalize, filter, sort and regroup data at the time of analysis. Intermediate and final totals are recalculated instantly.

The user is presented data in an electronic spreadsheet format.  By moving rows and columns or clicking them, the user makes the system perform calculations and show data in different aspects. Thus, the user can produce many reports out of a single dataset on his own, without any assistance from IT-specialists.

Filtered OLAP cubes: Argos supports filtered OLAP cubes in which cubes can be built off of ANY data source – you are not dependent on a data warehouse.

Note: You must be licensed for the OLAP module or the Interactive Charts module in order to create OLAP cubes or charts.

Charting

This option provides display of data using charts, gauges, maps, and other graphical elements providing an at-a-glance understanding of information.  Over 40 chart types (bar, line, gauge, 3D, and more) are provided.  Charts can be included in dashboards and banded reports.